{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["PMWS Severity Calculator"],"not_rendered":{"charts":0,"images":2,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"PMWS Severity Calculator","index":0,"n_rows":58,"n_cols":6,"rows_kept":58,"cut":false,"hidden":false,"merged":[[54,0,55,2],[57,0,57,4],[24,3,25,9]]}
[]
[]
[]
[]
[]
["Estimation of Post-weaning Multi-systemic Wasting Syndrome (PMWS) severity in your farm"]
[]
[]
["Please answer the following 9 questions (all questions require an estimate, otherwise the calculation cannot be carried out)"]
[]
[null,"Not affected             (no cases present)","Slightly affected (Few cases present and no increase in mortality)","Moderately affected (cases observed regularly)","Highly affected (High number of cases and increased mortality)","PMWS ordinal score"]
["1. Put an x in the column which best describes the level of PMWS in your weaners (pigs aged between weaning and 10 weeks) ",{"$nulls":4},{"$f":"IF(B12=\"x\",0,IF(C12=\"x\",1,IF(D12=\"x\",2,IF(E12=\"x\",3,0))))","v":0}]
["2. Put an x in the column which best describes the level of PMWS in your growers (pigs aged between 11 and 14 weeks) ",{"$nulls":4},{"$f":"IF(B13=\"x\",0,IF(C13=\"x\",1,IF(D13=\"x\",2,IF(E13=\"x\",3,0))))","v":0}]
["3. Put an x in the column which best describes the level of PMWS in your finishers (pigs aged 15 weeks or older)",{"$nulls":4},{"$f":"IF(B14=\"x\",0,IF(C14=\"x\",1,IF(D14=\"x\",2,IF(E14=\"x\",3,0))))","v":0}]
[]
[null,"Provide estimation of number of animals out of 100"]
["4. From 100 weaners (pigs aged between weaning and 10 weeks) produced in your farms, how many are affected by PMWS? ",1]
["5. From 100 growers (pigs aged between weaning and 10 weeks) produced in your farms, how many are affected by PMWS? ",0]
["6. From 100 finishers (pigs aged between weaning and 10 weeks) produced in your farms, how many are affected by PMWS? ",0]
[]
[null,"Give percentage"]
["7. Provide an estimate of the overall post-weaning mortality in your farm",5]
["8. Provide an estimation on the percentage of pigs (excluding gilts and sows) in your farm infected with Porcine Circovirus type 2 (PCV2)",10]
[]
[null,"Number of weeks",null,"*This parameter is only relevant to standarize the post-weaning mortality in the farm to a 22 weeks production cycle. For example, if your mortality is 7%  and you send your pigs to slaughter at an average age of 25 weeks, then the standarize mortality for a 22 weeks period will be 6.16%."]
["9. What is the average age of your pigs at slaughter (in weeks)*",22]
[]
["Standarization of morbidity variables"]
["Qualitative Weaner morbidity",{"$f":"(F12-0.6833333)/0.7776644","v":-0.87869947499204026}]
["Qualitative Grower morbidity",{"$f":"(F13-0.9416667)/0.8628255","v":-1.0913756025986714}]
["Qualitative Finisher morbidity",{"$f":"(F14-0.7916667)/0.7435531","v":-1.0647076853018298}]
["Quantitative Weaner morbidity",{"$f":"(B17-2.448167)/5.104028","v":-0.28373022248310559}]
["Quantitative Grower morbidity",{"$f":"(B18-2.93085)/5.596765","v":-0.52366858354781731}]
["Quantitative Finisher morbidity",{"$f":"(B19-1.76185)/3.182297","v":-0.5536409706573584}]
[]
["Estimation of Morbdity Factor 1",{"$f":"LN((B29*0.22655)+(B32*0.27117)+(B30*0.32128)+(B33*0.30782)+(B31*0.10466)+(B34*0.079785)+3)","v":0.72103183527183667}]
["MF1 standarized",{"$f":"(B36-1.056226)/0.2835422","v":-1.1821667629303978}]
[]
["Standarization of Post-weaning mortality"]
[]
["Mortality adjusted for 22.33 week production cycle",{"$f":"(B22*22.33)/B26","v":5.0749999999999993}]
["Post-weaning mortality standarized",{"$f":"(B41-7.857083)/5.186543","v":-0.53640411349139505}]
[]
["Standarization of prevalence of PCV2 infection",{"$f":"((B23/100)-0.3425545)/0.2049283","v":-1.1836066565720789}]
[]
["Your PMWS severity score is",{"$f":"LN((B37*0.6266)+(B42*0.5752)+(B44*0.5259)+3.48)*4.5","v":2.6656326017602749}]
[]
["Interpretation of the PMWS severity score:"]
[]
["If your PMWS severity score is <4","Non or Slightly affected by PMWS"]
["If your PMWS severity score between 4 and 6.5","Moderately affected by PMWS"]
["If your PMWS severity score is >6.5","Severely affected by PMWS"]
[]
["For further information on PMWS severity score, please read the following published article:"]
["Alarcon, P., et al., Assessment and quantification of post-weaning multi-systemic wasting syndrome severity at farm level. PREVET (2010), doi:10.1016/j.prevetmed.2010.09.022"]
[]
[]
["Please contact us if you have any questions on using this severity calculator or PMWS severity in general: palarcon@rvc.ac.uk"]